CREATE TABLE [dbo].[DocumentTypeRef]
(
[DocumentTypeCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DocumentTypeDesc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DocumentIconURL] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentTypeName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentNewLink] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentEditLink] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentExecuteLink] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskHelperAssemblyName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TrackVersionsFlag] [bit] NOT NULL,
[PublishWorkflowDocumentKey] [uniqueidentifier] NULL,
[RecycleWorkflowDocumentKey] [uniqueidentifier] NULL,
[FolderIconURL] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskHelperTypeName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentSummaryLink] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShortcutIconURL] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentTypeRefKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_DocumentTypeRef_DocumentTypeRefKey] DEFAULT (newid()),
[IsExportable] [bit] NOT NULL CONSTRAINT [DF_DocumentTypeRef_IsExportable] DEFAULT ((1))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[DocumentTypeRef] ADD CONSTRAINT [PK_DocumentTypeRef] PRIMARY KEY CLUSTERED ([DocumentTypeCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentTypeRef] ADD CONSTRAINT [AK_DocumentTypeRef_DocumentTypeDesc] UNIQUE NONCLUSTERED ([DocumentTypeDesc]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentTypeRef] ADD CONSTRAINT [AK_DocumentTypeRef_DocumentTypeName] UNIQUE NONCLUSTERED ([DocumentTypeName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentTypeRef] ADD CONSTRAINT [AK_DocumentTypeRefKey] UNIQUE NONCLUSTERED ([DocumentTypeRefKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentTypeRef_PublishWorkflowDocumentKey] ON [dbo].[DocumentTypeRef] ([PublishWorkflowDocumentKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentTypeRef_RecycleWorkflowDocumentKey] ON [dbo].[DocumentTypeRef] ([RecycleWorkflowDocumentKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentTypeRef] ADD CONSTRAINT [FK_DocumentTypeRef_DocumentMain_PublishWorkflow] FOREIGN KEY ([PublishWorkflowDocumentKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO
ALTER TABLE [dbo].[DocumentTypeRef] ADD CONSTRAINT [FK_DocumentTypeRef_DocumentMain_RecycleWorkflow] FOREIGN KEY ([RecycleWorkflowDocumentKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO